/*******************************************************************************
 * This file is part of blueprint4j www.blueprint4j.org.
 * 
 *     blueprint4j is free software: you can redistribute it and/or modify
 *     it under the terms of the GNU Lesser General Public License as published by
 *     the Free Software Foundation, either version 3 of the License, or
 *     (at your option) any later version.
 * 
 *     blueprint4j is distributed in the hope that it will be useful,
 *     but WITHOUT ANY WARRANTY; without even the implied warranty of
 *     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *     GNU Lesser General Public License for more details.
 * 
 *     You should have received a copy of the GNU Lesser General Public License
 *     along with blueprint4j. If not, see <http://www.gnu.org/licenses/>.
 ******************************************************************************/
package blueprint4j.db;

import java.math.BigDecimal;
import java.math.BigInteger;
import java.text.DateFormat;
import java.text.ParseException;
import java.util.Date;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Connection;

import blueprint4j.utils.*;

import java.text.SimpleDateFormat;

public class FieldDateTime extends Field implements BindDateTimeInterface {
    
    private static String date_format_description =  "yyyy-MM-dd HH:mm:ss";
    public static SimpleDateFormat date_format = new SimpleDateFormat(date_format_description);
    private boolean set_as_current = false;
    
    /**
     * public FieldDateTime( String p_name, String p_description, boolean p_key_field)
     *
     * Name: Name of field -> equivalent to table.field_name
     * Description: Description of field
     * key_field: Is this field a key field in the table (index field)
     */
    public FieldDateTime( String p_name, int p_field_type ,String p_description,Entity entity ) {
        super( p_name,p_field_type,p_description,entity );
    }
    
    public Field newInstance(Entity entity) {
        return new FieldDateTime(getName(),getFieldType(),getDescription(),entity);
    }
    
    protected void setFieldValue( ResultSet result_set )
    throws DataException {
        try {
            java.sql.Timestamp timestamp = result_set.getTimestamp( getName() );
            if (timestamp !=null) {
                setObject( new Date(timestamp.getTime() ));
            } else {
                setObject( null );
            }
        } catch ( SQLException se ) {
            throw new DataException( "Can not retrieve '" + getName() + "'" );
        }
    }
    
    public Date get() {
        return (Date) getObject();
    }
    
    public void set(Date value) {
        setObject(value);
    }
    
    public void setAsCurrent() {
        set_as_current = true;
        setChanged(true);
    }
    
    public String toString(){
        if (getObject() == null) {
            return null;
        }
        return getObject().toString();
    }
    
    /**
     * Return data in a suitable SQL format
     */
    public String getSQLValue()
    throws DataException {
        if (set_as_current) {
            return entity.getConnection().getDataBaseUtils().currentDateTimeSQLMethod();
        }
        if (getObject() == null) {
            return "null";
        }
        return entity.getConnection().getDataBaseUtils().convertDateTimeToSQLString(get());
    }
    
    /**
     * An overloaded equals method that only accepts the correct type
     */
    public boolean equals(Date value) {
        return get().equals(value);
    }
    
    public Object getPreparedStatementObject()
    throws DataException {
        if (getObject() == null) return null;
        return new java.sql.Timestamp(get().getTime());
    }
    
    public String getSerializable() {
        if (getObject() == null) {
            return "null";
        }
        return date_format.format(get());
    }
    
    public void setSerializable(String p_value) {
        if ("null".equalsIgnoreCase(""+p_value)) {
            setObject(null);
        } else {
            try {
                setObject(date_format.parse(p_value));
            } catch(Exception e) {
                Log.debug.out(e);
            }
        }
    }
    
    public String getTimeFormatDescription() {return date_format_description;}
    
    public SimpleDateFormat getTimeFormat() {return date_format;}
}
